Creating schemas for OIPA and IVS
To create schemas for OIPA and IVS execute the below SQLs by logging in as "admin" in the created ATP.
| SQLs |
|---|
CREATE USER <<Oipa Username>> IDENTIFIED BY <<Password>>; CREATE USER <<IVS Username>> IDENTIFIED BY <<Password>>; GRANT CONNECT,RESOURCE,CREATE TABLE,CREATE SYNONYM,CREATE VIEW to <<Oipa Username>>,<<IVS Username>>; GRANT CREATE SESSION TO <<Oipa Username>>,<<IVS Username>>; GRANT READ,WRITE ON DIRECTORY DATA_PUMP_DIR TO <<Oipa Username>>,<<IVS Username>>; GRANT DWROLE TO <<Oipa Username>>,<<IVS Username>>; GRANT EXECUTE on DBMS_CLOUD to <<Oipa Username>>,<<IVS Username>>; GRANT UNLIMITED TABLESPACE TO <<Oipa Username>>,<<IVS Username>>; |